COFOG Analysis
DS ACC PROG
gabriel kite
2024-07-12
1 Introduction
1.1 libraries
The libraries we will use are the following:
library (readr)
library(dplyr)
library(tidyr)
library(lubridate)
library(janitor)
library(tibble)
library(ggplot2)
library(plotly)
library(htmlwidgets)
library(gplots)2 Tables
2.1 Pivoted table
| Mode | 2015-01-01 | 2016-01-01 | 2017-01-01 | 2018-01-01 |
|---|---|---|---|---|
| Cash | 39971.0 | 3927.0 | 23165 | 25251.00 |
| Credit Card | 14367.0 | 0.0 | 26697 | 26405.00 |
| Debit Card | 0.0 | 0.0 | 0 | 461.00 |
| Equity Mutual Fund A | 0.0 | 0.0 | 0 | 113376.00 |
| Equity Mutual Fund B | 0.0 | 0.0 | 4000 | 18000.00 |
| Equity Mutual Fund C | 0.0 | 0.0 | 0 | 6049.00 |
| Equity Mutual Fund D | 0.0 | 0.0 | 0 | 106875.00 |
| Recurring Deposit | 0.0 | 0.0 | 14086 | 0.00 |
| Saving Bank account 1 | 293201.6 | 359280.5 | 1078335 | 334422.08 |
| Saving Bank account 2 | 0.0 | 0.0 | 0 | 690.15 |
| Share Market Trading | 0.0 | 0.0 | 100000 | 0.00 |
| Total | 347539.6 | 363207.5 | 1246283 | 631529.23 |
2.2 Heatmap
3 Plots
First we look at UK as a whole
3.1 Threshold Plots
3.2 Plotly Plots
The areas with outliers, based on LR, are the following:
4 Conclusion
Less than expected innit!